LOAD DATA 
 INFILE CONSTRUCCION.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE CONSTRUCCION
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   ID_CONSTR,
   DIRECCION 	NULLIF DIRECCION = BLANKS,
   AREA,
   USO 	NULLIF USO = BLANKS,
   DOMINIO 	NULLIF DOMINIO = BLANKS,
   NUM_PISOS,
   ID_PREDIO,
   Shape_Leng,
   Shape_Area,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
